ALTER VIEW [dbo].[View_Demo_StudentTe]
AS
SELECT
         dst.StudentGUID,
         dst.StudentName,
         dst.StudentAge,
         dst.StudentBirthday,
         dst.StudentHeight,
         dst.StudentIsVip,
         dst.StudentLevel,
         dst.ClassGUID,
         dst.StudentDesc,
         dst.StudentFavor,
         dst.TenantId,
         dst.IsDeleted,
         dst.CreateTime,
         dst.CreateGUID,
         dst.CreatedName,
         dst.ModifiedTime,
         dst.ModifiedGUID,
         dst.ModifiedName,
         dst.ApproveState,
         dst.ApproveGUID,
         dst.ApproveTime,
         dst.BuUnitGUID,
		 dst.StudentHeadUrl,
		 dst.StudentMeRemark,
		 dst.StudentFile,
		 dc.ClassName
FROM dbo.Demo_StudentTe dst
LEFT JOIN dbo.Demo_Class dc ON dst.ClassGUID=dc.ClassGUID